using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using KVB.Common;
using System.Data.SqlClient;

namespace Customer_Profile.Admin.DBDao
{
    public class UserLocationDao
    {
        public static DataSet GetUserLocationList(int userid)
        {
            SqlConnection conn = null;
            DataSet ds = null;
            try
            {
                DB.Connection(ref conn);
                string sql = "select * from dbo.TP_TUserLocation where id = " + userid;
                ds = DB.ExecuteDataset(conn, CommandType.Text, sql);
            }
            catch (Exception E)
            {
                Log.WriteDefaultLog("UserLocationDao.GetUserLocationList", E.Message);
            }
            finally
            {
                DB.ConnDispose(ref conn);
            }
            return ds;
        }
    }
}
